import sys
sys.path.append("../")
from model.CommonDb import *
from services.BaseService import *
from frameworks.utils.FileUtil import *
import pandas as pd
import datetime

class StockSelectService(BaseService):
    def __init__(self):
        super(StockSelectService, self).__init__()
        self.db = CommonDb("stock_select","stock")
        self.db1 = CommonDb("codes", "stock")

    def getSelectStock(self,actid):
        sql = "select c.* from stock_select ss left join codes c on ss.code=c.code where ss.actid='"+ actid +"'"
        return self.db1.executeMap(sql)
